Topics
Started by
Posts
Last post
Hi fellow DB folks, I've got a query that is puzzling me on how to make it work. I have two tables …
6 replies
Hi, I would like to update few data which is in SQL Server to MS Access. TableA in SQL Server 2005 …
1 replies
I have a situation where I have two copies of a database. One db with correct values in a column n…
8 replies
Let's say I have a software version 16.04.01 I set variables to get 1604 out of that value (see bel…
9 replies
I have a table with a column as dateentered with datatype varchar(10). I want to check this column …
5 replies
write a query to update column3 from table such that column3 contains whatever be the greater value…
5 replies
I need to join the order header and order detail tables; and create a new column calc based on head…
6 replies
if i create a function: CREATE FUNCTION dbo.MyFunction () RETURNS INT AS BEGIN RETURN 1 END SELECT…
11 replies
I need to export data to a text file within a Stored Procedure. The file name and location is alway…
2 replies
Hi Folks, I have a table which has the following data. DateLunValue 1/6/2009 22:42Lun17 1/6/…
3 replies
I have a SP that creates a temporary table whose rows (1000+) are looped through with a WHILE state…
8 replies
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
Viewing 15 topics - 7,861 through 7,875 (of 12,230 total)
You must be logged in to create new topics.