Topics
Started by
Posts
Last post
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
Okay, I have generalize SQL quesiton that I think belongs in this forum more than the General Quesi…
17 replies
I am doing a pretty simple update of Table_A, based on a join to Table_B The query runs on Server_A…
4 replies
I need to setup an SP to update a record in my table, however any incoming data my SP uses to make …
2 replies
Hi Friends, I have a table like Custmer bill Date location Bill_value 102 01-04-2011 …
6 replies
Hi All, I am in clean up mode from a previous DBA who loved to nest views when he was building scri…
5 replies
I need to change the column headings to start with a letter what would be the best way to do this.T…
5 replies
Hi guys, Just looking for some advice on the best way to go about this. Here's my example. So, I'm…
6 replies
I have a stored procedure building dynamic SQL based on input parameters, with a simple PHP web scr…
17 replies
This table has about 5M records and it takes about 300 milliseconds to execute below query. Just wo…
7 replies
Hi, I have 2 tables. Please see the attached screen shot for data. I need to join these 2 tables wi…
5 replies
the nulls come from not having data for a certain year for a customer. SELECT * FROM ( SELECT DIS…
3 replies
Viewing 15 topics - 601 through 615 (of 10,635 total)
You must be logged in to create new topics.