Topics
Started by
Posts
Last post
I have a classadmit date to from get date() - 24 hours. how to do it TSQl Thanks
3 replies
I am writing a UDF which takes tel numbers and converts them to the appropriate format. The first p…
5 replies
Hi, I am extracting data in comma delimited format and one of my rows has gone to the next line.&nb…
2 replies
Need SQL to render FIRST day of the year - based on select(getdate) Examples: If today's date is Ma…
7 replies
I have an SP that is supposed to select a record from the Projects table then Insert it "n" times b…
7 replies
I am using DatePart to strip the pieces out of a date field to create mm/dd/yyyy format. This…
3 replies
Dear all, I'm inheriting a database where there are many occurances of unwanted trailing blank spac…
3 replies
Hi im working on SQL2000 and im trying to create a maintenance trigger that will simulate the profi…
2 replies
I need to write a script which will find all instances of a table name containing the letters "XXXX…
4 replies
Hi, I have a stored proc that will update a certain row if it hasn't already been updated alread…
7 replies
Hi, I have an update statement in my stored procedure where I am updating the dates of a set of rec…
2 replies
Hello - In following stored procedure I am returning a row from a table that contains a column call…
2 replies
I need to return a recordset that has the following fields DepositNumber DepositDate Deposit…
3 replies
Hi I can create joins between two seperate DB's based on the same server without a problem, can I g…
5 replies
Is it possible to do the following using SELECT CASE: EXEC ('If NOT exists(Select * from Noti…
16 replies
Viewing 15 topics - 8,476 through 8,490 (of 17,082 total)
You must be logged in to create new topics.