Topics
Started by
Posts
Last post
hi all, How would I build a subquery to return different critiria to 2 seperate columns? thanks col…
2 replies
Is there a way of creating an identity column, or similar, on a result set? I have the situation wh…
1 replies
Hi! Just created a table to hold the locks snapshots, used: EXEC sp_tableoption 'BLOCKS_HISTORY', '…
2 replies
Kindly show me the equivalent of MSAccess Dsum() function
16 replies
I am trying to migrate to SQL Server from Oracle and I have trouble finding an equivalent to ROWNUM…
2 replies
I'm curious if some other developers would offer their opinions on best practicies for qualifing ta…
3 replies
Hi! I have a view, that lists "who blocks whom" information (below) After I get the results I use d…
3 replies
Hello, I have a hassle with this query. kind of hard to explain, but in plain English, I want to ru…
5 replies
Hi, I am using UNIQUEIDENTIFIER column for my table. I do not insert data for it. I left it on data…
9 replies
Hello, How are you today? I have 2 tables: Country_Codes Which contains: CODE-Code Name for a count…
1 replies
this query takes 1 minute and a half to execute when taking the top 500... it's going to be way to …
3 replies
--table in question has SSN column defined as char(9) declare @SSNchar(9) select @SSN = '996999993…
2 replies
I am trying to write a query that will return the following information sorted by region: Region de…
6 replies
The following statement works. On seems to work just like a where clause can someone tell me why? …
3 replies
Is it possible, within T-sql, to name a variable or key and include the value of another variable w…
3 replies
Viewing 15 topics - 14,956 through 14,970 (of 17,082 total)
You must be logged in to create new topics.