Topics
Started by
Posts
Last post
Hi Im trying to write a query to identify all system named FK's, DFs etc... Using some slightly a…
5 replies
I am using datediff functionm to calculate the days span between two dates SET @StartDate=cast('201…
7 replies
My data is in my table like this: F1 F2 F3 F4 F5 <-- col…
7 replies
Hi, Recently I came to one confusing issue about using TOP. Here is an example: Declare @a1 int , D…
1 replies
help me write below query: a start will also help 🙂 if drverri.despmce = space drverri.deinstn = d…
5 replies
Guys, Most of the time there are two/three record in the table. Example: I have 2 record with the v…
4 replies
Hello i want to save a xml file created in SQL Server from database values, how can i easiest and b…
1 replies
Hi , i am trying to build out T-SQL standard for our team , it would be followed for all T-SQL we w…
2 replies
Hi all, pls kindly advise on my query question below.. Table One: Item . Column : ItemCode (pk)…
7 replies
Hi, I need your help. I'm struggling to get my PIVOT right. My PIVOTED dates values does not matche…
1 replies
Ok I am a bit stuck I have a field that contains a mix of ranged data. All data is numeric; field t…
27 replies
Hello i am having trouble using parameters in select statement when using OPENROWSET in a stored p…
4 replies
Hello i have OPENROWSET query witch retrieves data from a database and put the resultset in a varia…
3 replies
I have a linked server to mySql from my sql server database. I have to issue create table statement…
2 replies
I have a procedure in which I'm having a problem with the proper syntax of passing parameters withi…
1 replies
Viewing 15 topics - 10,111 through 10,125 (of 10,647 total)
You must be logged in to create new topics.