Topics
Started by
Posts
Last post
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
Firtly, sorry about the title, not sure how to describe the issue 🙂 I have this code which works we…
2 replies
Hi, I want to record the connection and disconnection of SQL session i.e. any connections/disconnec…
1 replies
Dear Expert , I have a problem ...please help me out.. Conversion failed when converting the varcha…
4 replies
[font="Arial"]Hi , ***USING SQL SERVER 2008 R2**** I have used CTE to get to this partial result wh…
14 replies
Viewing 15 topics - 601 through 615 (of 10,647 total)
You must be logged in to create new topics.