Topics
Started by
Posts
Last post
My table and row as follow, declare @tBusType TABLE ( TrnxID int identity(1,1), [BusTypeCode] [nv…
4 replies
Hi , I am trying dynamic order by using Case statement in Order by clause. like declare @sortorder …
20 replies
Hi All, I have created one trigger on the table which would identify the hostname,username,app_name…
7 replies
I have a stored procedure that uses about 15 different cursors that look like this: DECLARE file_c…
10 replies
Hey guys, Ok I am working on a project and cannot figure out how to write a insert sp that will not…
3 replies
<Edit> This is now solved, but is a useful example of doing a TOP 10 sql query - includes dat…
7 replies
Hello, I am working on a stored procedure that will accept a column name and returns the name of th…
24 replies
This one is really strange and unfortunately I can't give an example of the bug. I did recreate the…
3 replies
Hi, I need help with a problem. I have a table with some columns (see below). I need to select the …
2 replies
Hi I want to displayed my total time in hours. For example, 7 hours 30 minutes should appear as…
11 replies
My Delete query which is below is taking too long to delete 20,494 records from a table. Basically …
2 replies
Not sure if my subject describes what I need help on, but hopefully it gives some idea. So I'm look…
2 replies
One user needs to do bulk insertion into database from excel file. I granted him BULKADMIN role as …
4 replies
I have a table called Schmoo and here is what Schmoo looks like: W, X, Sequence, Z (field names) 1,…
3 replies
Consider the following scenario. First table contains a list of requirements for bins to be repleni…
5 replies
Viewing 15 topics - 4,411 through 4,425 (of 12,234 total)
You must be logged in to create new topics.