Topics
Started by
Posts
Last post
select convert(varchar, datein, 101) DateIn, AdID ExternalAdID, count(LeadID) LeadCount, Case Le…
2 replies
SELECT Substring(J.MAP_NUM, 1, 4) as MAP_NUM_LIMITED, (SELECT Count(DISTINCT K.GPS_ID) FROM JUT K …
12 replies
we have a money feild which we need to remove the trailing zeros for example if we have something l…
4 replies
I've been working on creating a txt file from a proc. I've never done this from within a proc and i…
2 replies
Hi all, I am trying to get the cursor to update a value in table(s) from other database(s): Help wo…
3 replies
I have a point-in-time table in a SQL2000 database that has somehow gotten some overlaps inserted i…
2 replies
Hello, I've a table with primary key defined as non-clusterd, now without dropping it can I modify …
1 replies
I have a problem that just started where we insert data into a temp table with an order by then que…
3 replies
I don't know if a pivot table is the way to go, or if there is something better. I was asked to pr…
4 replies
Could someone tell me the difference between the following two syntacts --Using Set Declare @MyVar …
7 replies
can anybody help me? I have a stored proc that searches our help desk system. One of the columns in…
3 replies
I am trying to write a proc that gathers data and outputs it into a txt file. I have two problems t…
2 replies
Hi all, I have a table containing problem ticket information for our company. I want to create a vi…
2 replies
Hi there, I picked up a real gem of a project. We have an old VB4 (yes, I said 4) application that…
2 replies
Is it possible to dynamically format the text (font color, specifically) of a result set based on c…
1 replies
Viewing 15 topics - 3,256 through 3,270 (of 17,082 total)
You must be logged in to create new topics.