Topics
Started by
Posts
Last post
I have this case statement as part of my query - BUT it only evaluates the first line.. CASE WHEN …
3 replies
This might be really obvious but I cannot for the life of me figure out how to get a datetime value…
6 replies
How can you justify doing an upsert (update, if not exist, insert) with the use of @@rowcount. I am…
3 replies
Hi. I am trying to display a value as a percentage. In the formula below the values calculated manu…
3 replies
If more than 1 JobID exists in my [GroupData,GroupDetail] one-to-many relationship, I need to show …
3 replies
Hi, In German the decimal separator usually is a comma ",". OK, I am already used to using the dot …
3 replies
I've as T-SQL as follow, declare @FromDate datetime set @FromDate='1/1/2011' declare @ToDate Dateti…
6 replies
Hi I have a list of tables that I want to alter. How can I pass a variable (table name) to an Alter…
2 replies
Hello Everyone I am trying to gather some information about the use of Dynamic SQL, either from a f…
11 replies
Dear all, For over 2 weeks now, I have resisted coming here for help again for 2 reasons. 1, I worr…
48 replies
Is this possible? OraclePartNo = CASE WHEN Oracle_Part_ID IS NOT NULL THEN Oracle_Part_ID …
2 replies
Hi. I have a DueDate field in a table. I would like to set this value in a SELECT to be the current…
12 replies
I'm stuck, Please help. I have a database with multiple month values per individual in a single tab…
68 replies
I noticed Microcoft Excel seems to not really round-down, when you say format cells to 2 decimal pl…
3 replies
Hi All, Please let me know can we include two columns in UNPIVOT query. Does any body have sample q…
1 replies
Viewing 15 topics - 3,526 through 3,540 (of 12,234 total)
You must be logged in to create new topics.