Topics
Started by
Posts
Last post
Is it possible to nest (or perhaps stack via CTE) left and right? For example, if i had a list of …
9 replies
I have a situation where CONTEXT_INFO is currently being used in one area of our PROD instance on a…
1 replies
This is probably a simple join issue but here goes... We have a system (HAL) that does not contain …
4 replies
Hi ALL, SQL: Select MyColumn FROM ( SELECT CAST(CAST(0.10*100 AS numeric(10,2)) AS varchar(5)) + '…
15 replies
How do you surround a stored procedures parameters so that any with a single quote don’t cause a cr…
2 replies
How do you reference INFORMATION_SCHEMA.COLUMNS from a linked server? When I try doing that, I get …
6 replies
Im using sql2005 and in a simple query in the mngt studio return the error: Msg 21, Level 24, Stat…
11 replies
Hi, Does anyone have a list of all the IS (date/numeric) type syntax available? I've been trying to…
11 replies
Here's the scenario. Table CustomersA: RowIDCustomerNameCustomerIDCreationDateCreatedByValidat…
12 replies
Hi guys, I tried to create a new userdefined function for calculating the average of top 10 values …
3 replies
--===== If the test table already exists, drop it IF OBJECT_ID('TempDB..#mytable','U') IS NOT …
4 replies
1 : 7 ; 9 : 21:Task Completed:2013-04-08, 1 : 8 ; 10 : 22:Good:2013-04-08, 1 : 9 ; 8 : 19:N…
4 replies
Hello, I need syntax to get the all the values of one employee from the employee table, in …
4 replies
Hi, I have a scenario while comparing the data between two data sets. CREATE TABLE DATA (ID BIGINT,…
4 replies
Hi we can visualize a table as m*n matrix where m and n indicates number of rows and columns . But …
2 replies
Viewing 15 topics - 691 through 705 (of 12,234 total)
You must be logged in to create new topics.