Topics
Started by
Posts
Last post
I am creating a report in SRSS from a database that does not maintain historical data. To accomplis…
2 replies
For now we'll just consider one table, not the whole db. Say I have a table with the following inf…
5 replies
I have a column columnx of datatype float from a tabletablex and another column columny of the sam…
6 replies
How to PRINT below string pattern in T-SQL 2005: Input: SET @str = 'HELLO WORLD' Output: H HE HEL …
4 replies
Can't find any explanation behind it. Can anybody please explain me why the results of two select s…
4 replies
Hi guys, I know openrowset is possible to query result from sp, but want I need to query is somethi…
10 replies
Here is my code. When I print the update statement out I can copy and execute with no problem. Ho…
13 replies
I have a cursor that queries on a table based on a list of IDs. The problem I have is for each ID …
3 replies
which style do i use in convert(char(12),getdate, ) to display in dd-mmm-yyyy pattern in sql
5 replies
I have a scenario that I KNOW should be fairly simple to write, but I am completely blanking as to …
17 replies
I have a table called CT_FS_Import_Revised that contains a TicketNumber and a TrackingNumber. In so…
9 replies
Hi, If I update multiple rows in table in a single sql statement, as I understand it, the update tr…
6 replies
Hi guys, got a problem here,cant get this to work DECLARE @FIELD CHAR(50) DECLARE @VALUE CHAR(4) SE…
3 replies
Given the following sample data, is it possible to produce a set of rows that group on column v whe…
10 replies
So here are the facts: I have my SQL server linked into a Teradata server. I can run my queries jus…
2 replies
Viewing 15 topics - 7,876 through 7,890 (of 12,230 total)
You must be logged in to create new topics.