Topics
Started by
Posts
Last post
I need to create a running count of LOGINS based upon the Year, Month, Day and Hour. If there…
11 replies
Select empid from tblemp. Result set: 244 254 253 I want to check if each empid is either Accepted …
2 replies
Hello, First time posting, stuck on a problem. Please bear with me if what I say is not prop…
15 replies
Is it possible to define snapshot isolation level for view? I have not found any view setting or ta…
2 replies
I need to retrieve the latest description on a specific case. I am joining to the following table u…
16 replies
I have three stored procs and one main caller proc which will call those three procs. How can we jo…
6 replies
hey guys, i have a Tsql using case with the following output ID apple…
8 replies
EXEC sp_addlinkedserver '192.168.1.1' EXEC sp_addlinkedsrvlogin @rmtsrvname = '192.168.1.1', @usese…
15 replies
I am getting the following error Msg 245, Level 16, State 1, Procedure TESTspCleanUp, Line 18 Synt…
1 replies
Hello, I am storing a time value into database using a DateTime datatype where the date portion is …
10 replies
Silly question, but how can I store the XML returned from a SELECT FOR XML statement? Basically, I …
4 replies
SQL Query question. what if I know what data I what to find in a database, but I don't know the tab…
11 replies
Can any one pls check my query at the CASE function. alter Procedure [dbo].[getlist] as begin sel…
6 replies
I have a query with many subqueries that use the same filters. Is there a way I can list the filte…
10 replies
hello am using the follwing SELECT Sum(IIf(attendance.present='P',1,0)) AS TotalPresent …
1 replies
Viewing 15 topics - 4,486 through 4,500 (of 17,082 total)
You must be logged in to create new topics.