Topics
Started by
Posts
Last post
I have the following snippet as part of a query I'm running: CREATE TABLE #TempTable (ID1 int, ID2 …
4 replies
I am building up some dynamic t-sql to produce a recordset where one of the parameters sets the whe…
1 replies
Hi i have a image field which i insert images, i make it with sp_textcopy. First i upgrade field to…
2 replies
Hi all, I am new to the SQL Server (2000) world after working with Oracle for a while. My problem i…
12 replies
Hai Everybody, I want to get the Last Altered Date and Time of the Table. and also want to know ho…
2 replies
Hi I want to find out the exact numeric part prom the string. I am using Patindex but the pro…
1 replies
I have the following problem I have a view which has a NetCost figure calculated as Rate Per Item *…
8 replies
Does anybody know how to do this? SELECT CASE WHEN SHARE.BALANCE <=50 T…
1 replies
Can anyone tell me why the: HAVING sum (accounts_receivable_history.amount) + sum(accounts_receivab…
8 replies
I know this is easy but I want to turn the data as a column SELECT [$0-$50]= SUM(…
3 replies
To all I have a store procedure that update a table . How can I use a trigger to use the store pro…
1 replies
As part of a script I have the following code. The idea is to retrieve specific data from emails wh…
3 replies
Server: Msg 18025, Level 16, State 1, Line 0 xp_startmail: failed with mail error 0x80040111 …
3 replies
As a part of a bigger script I am writing which iterates through each database, I want to extract i…
2 replies
FYI: ***** Answer = Case Statement ****** This has been racking my brain for the past few wee…
10 replies
Viewing 15 topics - 7,651 through 7,665 (of 17,082 total)
You must be logged in to create new topics.