Topics
Started by
Posts
Last post
I need to update a date field for all records in a table to change the year from 2008 to 2009. I ha…
4 replies
Hi, I'm looking for some guidance on an update query which is proving a little trickier than I firs…
10 replies
I am trying to avoid wrapping code around my date type columns on some of the queries in stored pro…
3 replies
declare @a char(4) set @a='Eur' select iff(@a="Eur","Euro","chke") is giving me the below error Msg…
1 replies
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
Viewing 15 topics - 7,876 through 7,890 (of 12,234 total)
You must be logged in to create new topics.