Topics
Started by
Posts
Last post
Hi, I have inherited a report from a old colleague and you can see that he has used the FOR XML Pat…
4 replies
Hi, I have been out of the MSSQL world for about 5 years so trying to catch up. I found this wonder…
10 replies
Hi No doubt this is standard behaviour I should already know about, but I'm a little unclear about …
15 replies
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
Viewing 15 topics - 766 through 780 (of 10,635 total)
You must be logged in to create new topics.