Topics
Started by
Posts
Last post
I am having a huge problem with my stored procedure which is cozing a table locking and I can't fig…
4 replies
hi, i've been requested to encrypt a password column in a table on our database. This is the first …
5 replies
I need to write a SQL script that will take a sales transaction and then look at the payments durin…
5 replies
I have a Query in SQL Server 2000 as follow that I need to migrate to SQL server 2005 . This query …
5 replies
Hi, SELECT C.RCN_ID As CandidateID, I.RIV_ID As InterviewID FROM Abacus_Rec_INTERVIEW AS I …
8 replies
Anyone have suggestions on how to get this WHERE statement to work? WHERE CASE WHEN dbo.Firms.Chi…
19 replies
I have a table that tracks the progress of steps in our sales process. Our process allows for sale…
7 replies
I am trying to create a udf for PV function from Excel: PV(rate,totalperiod,payment, futurevalue). …
1 replies
Hey there group, I need to build a function that takes in a date and then returns the corresponding…
29 replies
I need to do about 500,00 rows this way and it is currently done in a CURSOR..way to long.. some h…
3 replies
how would i get around this issue with 2 columns that i need to insert with the same values. insert…
12 replies
Hi All I am comparing 2 counts in a stored procedure. Basically i have this :- DECLARE @AllMarkets…
5 replies
I have a table that has data that appears like: ID Date (YYYYMM) 01 200811 01 …
4 replies
I'm trying a SQL Job step in which I want to call a stored procedure and pass in some parameters. …
8 replies
I have 7 fields that I need to concatenate into one, but I need to convert 0 and -1 to actual words…
1 replies
Viewing 15 topics - 8,236 through 8,250 (of 12,230 total)
You must be logged in to create new topics.