Topics
Started by
Posts
Last post
I am trying to do this Declare @filename varchar(125) set @filename = 'C:\testdata.xml' select Bulk…
2 replies
hi guys can anyone tell me if they see something wrong with this line SET IDENTITY_INSERT ''+ @TAB…
3 replies
Is it possible to call a function from sp_executesql? I need to specify the function name with a v…
8 replies
I have two tables with identical structure – Table1 & Table2. Both tables have rows in them. …
3 replies
I have a simple table create table user_logins ( userlogin datetime, userlogout datetime, logindom…
10 replies
I want to pull records from a "Column" within a "Table". I recall in the past doing a: SELECT COUN…
2 replies
I want to BULK INSERT a .csv file to a table and have the table autogenerate a PK for each row. I…
4 replies
hello, here i return for another problem thats been causing me hassle, I am not sure if i am going …
6 replies
i have two tables T1 and T2. Both has the same schema. I am inserting a few records manually in T1 …
5 replies
Hi there, I need to select rows from a table, but include the top 3 rows of another linked table as…
3 replies
I'm trying to split a string and relate it to the row from which it came but I'm having some troubl…
4 replies
Is using too many temporary tables (#Temp..) in an SP, a bad practice by any chance? Or does it ham…
27 replies
In many of our reports we query the Time table to get staff time data. Now each staff is assigned t…
2 replies
select getdate() as todaydate, cast(getdate() as varchar) "diff format" ,cast(getdate()+1 as int) a…
20 replies
I need a query that gets all of the databases on a server and determines if a backup has been taken…
2 replies
Viewing 15 topics - 10,591 through 10,605 (of 12,230 total)
You must be logged in to create new topics.