Topics
Started by
Posts
Last post
Hi guys please look at my query below and comments: CREATE TABLE TempDate( RowID INT NULL, Workorde…
4 replies
IF OBJECT_ID('TestData', 'U') IS NOT NULL BEGIN DROP TABLE TestData END IF OBJECT_ID('TestResults',…
4 replies
I have a table full of events with dates, start times, and stop times. Many of these events happen …
3 replies
HI, I looking to create a tmp table of dates as simply as possible in tsql. Examples online take a …
12 replies
Here is the solution I developed to my last post! But where did my last post go? PROCEDURE [dbo].[A…
7 replies
Is there a way to write this query in better way declare @listofids varchar(max) select @listofids…
10 replies
Hi guys, Hope all are doing good. I just wanted a idea on report buiding query. Like , i actu…
5 replies
I'm trying to use BULK insert a flat file. The file has a header row. In addition to the delimiter…
8 replies
Hi folks, I am having tblActivity where we are tracking all login details of employee. Main columns…
4 replies
My sp has @StartDate (month and day will always be 11 and 01 ie November 1 and the year just change…
3 replies
Hi I need to be able to compare current data to previous. e.g if my query is: Select Count(WorkOrde…
6 replies
My sp has @StartDate (month and day will always be 11 and 01 ie November 1 and the year just change…
1 replies
Firstly I must admit I learned t-sql on my own and my syntax I know is not the best as I use temp t…
7 replies
The query looks similar to: SELECT STUFF((SELECT ISNULL(field + CHAR(10) + CHAR(10),'') FROM FOR X…
9 replies
Hey guys this is probably an easy one for you all here. I have been working on this Subquery in a S…
6 replies
Viewing 15 topics - 586 through 600 (of 10,647 total)
You must be logged in to create new topics.