Topics
Started by
Posts
Last post
DECLARE @Data TABLE ( PrimaryKeyID INT NOT NULL IDENTITY(1,1), DateStart DATETIME NOT NULL, Date…
12 replies
--I know this has to do with an implicit conversion of the varchar to int, --but why does the zero …
25 replies
I have an nvarchar column called rptnum in a table that I have created a .NET routine to insert a r…
3 replies
I am trying to set up a variable @Location, for use in a where .. IN, but can not seem to get it to…
8 replies
I am not exactly a "noob" as I am a .net developer, however I lack in SQL query knowledge and need …
4 replies
I have a package set to run in 32bit mode on a 64bit machine, and I need to put it in a stored proc…
19 replies
Hi folks Hoping someone can help me find a more efficient way of doing the following. I have a tabl…
2 replies
I don't know why I cannot figure this one out and I don't need anyone to write the procedure for me…
4 replies
Hi, In our invoice SP we pass the data as XML to send all the rows at once to the database. To go t…
11 replies
I have created a pdf signing method that works in asp.net and then at the end I want to update it t…
1 replies
Hello Friends, I have a challenging problem to solve ! I have two tables as shown below, I'm trying…
4 replies
Hi All, I am trying to create xml files in SQL 2008 R2 with 'for xml path'. I have not got experien…
2 replies
I am trying to create a sql server computed column with an alter statement below,but I can't seem t…
2 replies
Hi, Sample data to play with Declare @Company table(CompId int,CompanyName varchar(30)); Declare @U…
3 replies
I have a querythat works in SQL Server 2005, but has an error using it in SQL Server 2008. select …
11 replies
Viewing 15 topics - 766 through 780 (of 10,647 total)
You must be logged in to create new topics.