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.
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy