Topics
Started by
Posts
Last post
Hi, I have the following sample table. cust_num slsman site sales_ytd c000200 904 11199 1023.1 c000…
6 replies
I have a table with the following data: SeqNbr Value EffDate SubCategory Category 1 …
5 replies
Hi All, Here is my SQL Query, This query should not fetch duplicate contactID(i.e Same ContactID).b…
6 replies
By: OTF
Hi folks, I have a big stored procedure, it is a long sp with long redundant queries, for example: …
6 replies
I am trying to return a result set and I can not quite get my head around it at the moment. I know …
30 replies
I have a a grid on my asp.net page and grid has a delete link by which i delete a row from grid so …
3 replies
Hi, I found a piece of SQL that contains a cursor and seems slow. I would like to optimize it but …
5 replies
By: WayneS
Hi, I build some t-sql code to check if full text is installed on the sql server. If not, some sql …
13 replies
By: lukezy
i have table column in sql server like this dat1/dat2/dat3/dat4/1/2009 dat1/dat2/dat34/dat4/2/2009 …
5 replies
A request has been made for some users to be able to drop databases from a test server themselves, …
4 replies
By: Ram:)
declare @dynasql nvarchar(500) declare @dynawhr nvarchar(500) declare @dynacon int declare @msg_use…
22 replies
I have got MailDate with me. I just need to check the condition weather MailDate>=CalenderDays. …
5 replies
Hi, I have a staging table that contains data obtained from a xml file import via SSIS. In instance…
3 replies
Hi all, Recentlly i updated my SQL database server to 2008, I am using Microsoft SQL server Managem…
1 replies
Hello I'm trying to find the local windows group membership on the local machine through a tsql scr…
1 replies
By: barsuk
Viewing 15 topics - 3,466 through 3,480 (of 12,230 total)
You must be logged in to create new topics.