Search results for query: *

Hello everyone, Need some guidance on how best to approach this. I have data where I am presented with the following Contract ContractStartDate ContractEndDate A-S00027491 2020-08-06 00:00:00.000 2022-08-06 00:00:00.000 A-S00027526 2020-08-13 00:00:00.000 2022-08-13 00:00:00.000...

Hello everyone, and thank you in advance for your help. I have JSON files that I am working on importing into SQL. I am able to access the general data, but there is some data where it contains an Array of data (just a listing) which may be 0 rows, or 100. I am unable to determine how to...

I have a requirement to parse apart a field of data that is separated by a semi-colon, to do some work on the individual results (transform based on a case statement), and then to reassemble so that they are in the format of (value; value; value). I can separate and perform the case statement...

Hello everyone, I have run into a couple of problems that are baffling me. I am able to select XML data if the variable @MyXML is populated using text and a SET command, but if I populate @MyXML using a select statement it will not allow me to parse the variable and return results. For...

Hello everyone, I have a Matrix Report written in 2005 where the Matrix/columns is Dynamic. I am experiencing an issue where the report renders correctly, it exports to other formats correctly, however.... when Printing only the first 6 columns of the Matrix display their labels. The...

Hello everyone, first of all thanks for your help up front. I have a complex update statement that runs once a month against a large db, it was never very fast but we recently moved from SQL 2000 to 2005. The speed has drastically decreased, and it is filling up the Tempdb. On occasion the...

Hello everyone, and Thanks in Advance. I have a query that has me stuck, unless I use a cursor and I believe there has to be a better way than that. I have a table that holds records of classes, I need to run a query that returns one class for each month after a given date. So if my 1st table...

Thank you in advance for your assistance. I am unable to deploy any report from Visual Studio 2005 since I upgrade my Report Server. (2000 to 2005). When I select the either the project, the individual report, or the data source I receive: ------ Build started: Project: Report Project3...

Hello everyone, I have an application that I am trying to use to search multiple OU's and it fails. It will work fine if I define the OU I want to search, but if I try and search a subtree if fails producing an error of "Unknown error (0x80005000)". I really need help resolving this, as I...

Hello everyone, I am frequently having to create fixed field length files for import into a system. I know how to do this with DTS, I am just very tired of the troublesome steps it takes to adjust a deal with. Does anyone know of a utility that will will export to fixed field length fields...

I have encountered a problem where I am writing out a XML file using XMLTextWriter (the principles here should be the same whether it is a XMLTextWriter, or just a TextWriter. I am successfully writing the file, however it is 2.5GB in size. I am trying to change the logic to create multiple...

I am trying to perform a validation of XML files using XSD Schema's. However when I perform the validation it instantly skips right through the line of code without performing any validation. The XML files I am running this against are large (20 MB and larger), so I know it should take a...

I am working with an application that I am writing out a cookie with a encrypted username and password. However, I cannot get the cookie to write out, or at least I cannot tell that I am writing it, as I am unable to read it. The code writes the cookie and then redirects to a new page on the...

I am revisiting an aspx page I wrote a while back that needs some performance improvements. When I wrote the page it was early in my understanding of c# and asp.net (not that much further along now...) The problem I had, is that I had to repopulate values every time I posted back to the page...

I need to write a web app that performs a simple operation, but I am a little lost in how to go about it. If you can even just point me in the right direction I would appreciate. I have a web application that I am working on, the desire is for users to enter their network domain userid and...

I would like to thank everyone far in advance for any help they can give me on this quesiton. I have several statements that perform what should be a simple update on a single table. However, when placed against a full production load it has never completed (I probably don't have the patience...

I am trying to figure out how to use a select statement to populate multiple variables. I am very familiar with how to populate one variable using select. ie. Select xcode into Code from course; But I would like to populate multiple codes, and have tried a statement such as this. Select...

I have a database that stores class information. Each class has a different number of sessions, some 1 and some 5. I need to run a query that shows if all the sessions for a course have been completed, but only if one of the courses falls within the defined time frame. My (simplified) table...

Hello everyone, I am writing out a file from a dataset using WriteXML. However, I need to add attributes to a couple of elements. How can I add an attribute to the elements? I can either hardcode the attributes, or put them in the result set, or dataset name. My code looks like this...

I hope my subject was correct. I am very new to this. I am exporting out data and have a requirement to match a customers schema. Using C# I have been able to create the beginning of an XML document. So far the content of my document looks like this: <?xml version="1.0" encoding="utf-8" ?>...