Topics
Started by
Posts
Last post
Hi , i found the following code snippet: { fn WEEK(Created) } It does select the week from a date. …
6 replies
I have a procedure whose last line is a select statement. Hence this proc gives me a result set in …
10 replies
Hi, within a trigger I use the command DBCC INPUTBUFFER (@@SPID) WITH NO_INFOMSGS to capture the st…
3 replies
I have a lookup table. RefType EngCode EngDesc ---------------------------------------- Fe…
15 replies
using sql 2000, I'm trying to create 1 row from a union query. This is needed by a DNN module to c…
3 replies
I am searching a single TEXT column for 25+ keywords and I need to return the recordID and the matc…
9 replies
Hi, I am trying to convert an integer to text in a query using: CASE WHEN [Extension]<'80' THEN …
7 replies
Hi, I have two tables of news feed NewsHeader & NewsDetails NewsHeader: Time H…
1 replies
Can we have multiple tables in the same cursor? Also I want to know where we will use stored proced…
2 replies
Hi All, I need some help regarding my career plan Presently i am working as SQL Server DBA and re…
1 replies
I have a proc that creates a txt file. The sp uses a local variable that is declared as a varchar(8…
11 replies
Dear All I have the following function that the returns the value with comma delimitor ex: FormCode…
1 replies
I have a application which records time in ASCII value in our database. I need to convert the ASCII…
9 replies
I'm troubleshooting a system that is able to process data overnight, but takes forever to complete …
7 replies
Hi,all I have a following query , select distinct bg.bg_id [BugId], (select top 1 bgAudit.bgstad_ad…
2 replies
Viewing 15 topics - 2,926 through 2,940 (of 17,082 total)
You must be logged in to create new topics.