Topics
Started by
Posts
Last post
There is a Table. CREATE TABLE TBLCOLOR (ID INT, COLOR VARCHAR(20)) Insert into TBLCOLOR SELECT 1,'…
21 replies
What's wrong with my procedure? The error msg: Msg 156, Level 15, State 1, Procedure sp_GetInapprCo…
3 replies
I have to create a table where one column is populated using GETDATE(). How do I add that in to thi…
1 replies
How to select comma separated columns data, i was using below query but due to large data it is kil…
2 replies
How do i convert the below date from Mon Jan 28 11:03:06 EST 2013 To 2013-01-28 11:03:06 Thanks for…
8 replies
Hi, I executed the following query: SELECT [Extent1].[ExerciseYear] AS [ExerciseYear], [Extent1]…
8 replies
Hello All, Can I insert the results of a stored procedure into a dynamic table? I am looking for th…
2 replies
I need to order the following Query by the auditdate field, which is unfortunately a MAX. Anybody h…
7 replies
Straight-forward...at least I though so...I made certain all stats for this were updated, yet still…
9 replies
Hi, Im trying to create a high score list from a log table. I want to retrieve the personal best of…
1 replies
Hello Everyone, Currently I am having an issue, I did my SQL Script and it takes a decent amount of…
5 replies
I want to know how order of joins executed in sql server. Suppose i have used 3 tables in join. tab…
5 replies
I have a table that my company uses for logging. One of the columns is declared as: event (sysname(…
2 replies
hello, Is there a way in whihc we can combine the out of sp_who2 with sysprocesses table in sql 200…
3 replies
Friends, One of my colleagues sent me the following code: DECLARE @TMP TABLE (RecID INT, Number IN…
5 replies
Viewing 15 topics - 4,336 through 4,350 (of 10,636 total)
You must be logged in to create new topics.