Topics
Started by
Posts
Last post
I have a sql query SELECT PropertyName, PropertyValue, UserID FROM ProfilePropertyDefinition INNER…
12 replies
hi. i have a cursor. it gets 3 rows from a table. I am 100% sure there are only 3 rows in the #File…
3 replies
I have a table that I want to add an identity column too. The existing records need to have the val…
7 replies
Any ideas on how to convert this function from cursor base to a for/next loop? CREATE funct…
6 replies
Hi Folks, I have a database table named Stores that includes following columns StoreID int, S…
11 replies
I support a third party application where an end user will execute something from the app and the f…
2 replies
Hello, I have a query that contains six derived columns; FirstPerYr; The current year FirstPerMo; T…
2 replies
Hello, I have a table that looks like this. It has 18 columns of sales data. fields: fldProduct,fld…
10 replies
Hi everyone Can anyone offer some advice on how to show the IP address of current connect machine w…
4 replies
Hi everybody, I have this small request: If I run GETUTCDATE(), I get the UTC time with time at the…
2 replies
Hello, I'm getting a cross join result from the following query; SELECT DISTINCT RTRIM(DA.AcctCod…
6 replies
If I have the following 2 fields in a table, is there a way to select the Id and the RESULT of…
9 replies
Can anyone help with this one? I am doing a straitforward sum on a table with character, integer an…
6 replies
I wish to do a reversal of money i.e if 5.55 i want -5.55 if -6.55 i want 6.55 is their a fuction w…
2 replies
Hey everyone, I have read the forum on single quotes: http://www.sqlservercentral.com/forums/shwmes…
4 replies
Viewing 15 topics - 5,191 through 5,205 (of 17,082 total)
You must be logged in to create new topics.